﻿CREATE TABLE [dbo].[tblWH_DbTblInd_Names]
(
	[btw_id] INT IDENTITY(1, 1) NOT NULL,
	[btw_server_ssd_id] INT NOT NULL, 
	[btw_databaseid] INT NOT NULL, 
	[btw_tableid] INT NOT NULL, 
	[btw_indexid] INT NOT NULL, 
	[btw_databasename] VARCHAR(256) NULL, 
	[btw_tablename] VARCHAR(256) NULL, 
	[btw_indexname] VARCHAR(256) NULL, 
	[btw_startdate] DATETIME NOT NULL CONSTRAINT [DF_tblWH_DbTblInd_Names_startdate] DEFAULT ('01/01/1900'),
	[btw_enddate] DATETIME NULL, 
	CONSTRAINT [PK_tblWH_DbTblInd_Names] PRIMARY KEY ([btw_id])
)
GO

CREATE INDEX [IX_tblWH_DbTblInd_Names_DbTblInd] ON [dbo].[tblWH_DbTblInd_Names] ([btw_databaseid], [btw_tableid], [btw_indexid])
GO